package io.renren.modules.com.dao;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import io.renren.modules.com.entity.ComAItemEntity;
import io.renren.modules.sys.dao.BaseDao;

/**
 * 
 * 
 * @author pfp
 * @email
 * @date 2017-07-27 16:42:49
 */
@Mapper
public interface ComAItemDao extends BaseDao<ComAItemEntity> {

	void deleteByCrSerialNo(Long crSerialNo);

	void deleteEVA(@Param("crSerialNo") Long crSerialNo, @Param("yearMonth") String yearMonth);

	void deleteBatchByCrSerialNos(Long[] crSerialNos);

	int querya(Map<String, Object> map);

	int queryb(Map<String, Object> map);

	Double queryd(Map<String, Object> map);

	Double querye(Map<String, Object> map);

	Double queryg(Map<String, Object> map);

	List<ComAItemEntity> queryByCrSerialNo(Long crSerialNo);

	String minYearMonth(Long crSerialNo);

	String maxYearMonth(Long crSerialNo);

	List<ComAItemEntity> findMore(Map<String, Object> map);

	List<ComAItemEntity> fuckShitDamn(Map<String, Object> map);

	List<ComAItemEntity> turnover(Map<String, Object> map);

	List<ComAItemEntity> iphone(Map<String, Object> map);

	List<ComAItemEntity> iphonePlus(Map<String, Object> map);

	List<ComAItemEntity> veteran(Map<String, Object> map);

	int turnoverTotal(Map<String, Object> map);

	List<ComAItemEntity> apportionment(Map<String, Object> map);

	List<ComAItemEntity> alphabetBear(Map<String, Object> map);

	List<ComAItemEntity> kumamon(Map<String, Object> map);

	List<ComAItemEntity> oldDriver(Map<String, Object> map);

	ComAItemEntity minMax(@Param("crSerialNo") Long crSerialNo, @Param("item") String item);

	Double sumJapan(Map<String, Object> map);

}
